<?php
/* MySQL connection */
include( $_SERVER['DOCUMENT_ROOT']."/datatables/mysql.php" ); /* ;-) */

$gaSql['link'] =  mysql_pconnect( $gaSql['server'], $gaSql['user'], $gaSql['password']  ) or
die( 'Could not open connection to server' );

mysql_select_db( $gaSql['db'], $gaSql['link'] ) or
die( 'Could not select database '. $gaSql['db'] );

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" type="image/ico"
	href="http://www.datatables.net/favicon.ico" />

<title>DataTables example</title>
<style type="text/css" title="currentStyle">
@import "../../css/demo_page.css";

@import "../../css/demo_table.css";
</style>
<script type="text/javascript" language="javascript"
	src="../../js/jquery.js"></script>
<script type="text/javascript" language="javascript"
	src="../../js/jquery.dataTables.js"></script>
<script type="text/javascript" charset="utf-8">
			$(document).ready(function() {
				var iStart = new Date().getTime();
				if ( typeof console != 'undefined' ) {
					console.profile();
				}
				var oTable = $('#example').dataTable();
				//var oSettings = oTable.fnSettings();
				if ( typeof console != 'undefined' ) {
					console.profileEnd();
				}
				
				//if ( typeof console != 'undefined' ) {
				//	console.profile();
				//}
				//oTable.fnSort( [[1, 'asc']] );
				//if ( typeof console != 'undefined' ) {
				//	console.profileEnd();
				//}
				
				var iEnd = new Date().getTime();
				document.getElementById('output').innerHTML = "Test took "+(iEnd-iStart)+"mS";
			} );
		</script>
</head>
<body id="dt_example">
<div id="container">
<div class="full_width big"><i>DataTables</i> performance test - draw</div>
<div id="output"></div>

<div id="demo">
<table cellpadding="0" cellspacing="0" border="0" class="display"
	id="example">
	<thead>
		<tr>
			<th>id</th>
			<th>name</th>
			<th>phone</th>
			<th>email</th>
			<th>city</th>
			<th>zip</th>
			<th>state</th>
			<th>country</th>
			<th>zip2</th>
		</tr>
	</thead>
	<tbody>
	<?php
	$sQuery = "
		SELECT *
		FROM   testData
		LIMIT  2000
	";
	$rResult = mysql_query( $sQuery, $gaSql['link'] ) or die(mysql_error());
	while ( $aRow = mysql_fetch_array( $rResult ) )
	{
		echo '<tr>';
		echo '<td>'.$aRow['id'].'</td>';
		echo '<td>'.$aRow['name'].'</td>';
		echo '<td>'.$aRow['phone'].'</td>';
		echo '<td>'.$aRow['email'].'</td>';
		echo '<td>'.$aRow['city'].'</td>';
		echo '<td>'.$aRow['zip'].'</td>';
		echo '<td>'.$aRow['state'].'</td>';
		echo '<td>'.$aRow['country'].'</td>';
		echo '<td>'.$aRow['zip2'].'</td>';
		echo '</tr>';

		//echo '<tr>';
		//echo '<td>'.$aRow['id'].'</td>';
		//echo '<td>'.$aRow['name'].'</td>';
		//echo '<td>'.$aRow['phone'].'</td>';
		//echo '<td>'.$aRow['email'].'</td>';
		//echo '<td>'.$aRow['city'].'</td>';
		//echo '<td>'.$aRow['zip'].'</td>';
		//echo '<td>'.$aRow['state'].'</td>';
		//echo '<td>'.$aRow['country'].'</td>';
		//echo '<td>'.$aRow['zip2'].'</td>';
		//echo '</tr>';
	}
	?>
	</tbody>
</table>
</div>
<div class="spacer"></div>


<div id="footer" style="text-align: center;"><span
	style="font-size: 10px;"> DataTables &copy; Allan Jardine 2008-2009. </span>
</div>
</div>
</body>
</html>
